﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using System.Web.DynamicData;
using System.Data.SqlClient;

namespace sistemaAcademicoFinanceiroEscolas.DynamicData.CustomPages.valorEspecialGrupo
{
    public partial class List : System.Web.UI.Page
    {
        protected MetaTable table;

        protected void Page_Init(object sender, EventArgs e)
        {
            DynamicDataManager1.RegisterControl(GridView1, true /*setSelectionFromUrl*/);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            table = GridDataSource.GetTable();
            Title = table.DisplayName;

            //InsertHyperLink.NavigateUrl = table.GetActionPath(PageAction.Insert);

            // Disable various options if the table is readonly
            if (table.IsReadOnly)
            {
                GridView1.Columns[0].Visible = false;
                //InsertHyperLink.Visible = false;
            }

            //DynamicFilterForm1.Focus();

        }

        protected void OnFilterSelectedIndexChanged(object sender, EventArgs e)
        {
            GridView1.PageIndex = 0;
        }

        protected void RowDataBound(object sender, GridViewRowEventArgs e)
        {

            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                sistemaAcademicoFinanceiroEscolas.valorEspecialGrupo gp = (sistemaAcademicoFinanceiroEscolas.valorEspecialGrupo)e.Row.DataItem;

                string codigoValorEspecialGrupo = gp.codigoValorEspecialGrupo.ToString();

                string sqlGrupos = "SELECT codigoValorEspecialGrupo, codigoGrupo, dataInicialValorEspecialGrupo, dataFinalValorEspecialGrupo, valorValorEspecialGrupo, ";
                sqlGrupos += "(SELECT nomeAluno FROM aluno WHERE (codigoAluno = valorEspecialGrupo.codigoGrupo)) AS Grupo ";
                sqlGrupos += "FROM valorEspecialGrupo WHERE (codigoValorEspecialGrupo = " + codigoValorEspecialGrupo + ") ";

                SqlConnection sqlc = new SqlConnection(ConfigurationManager.AppSettings["baseDados"]);
                sqlc.Open();

                SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sqlGrupos, sqlc);
                SqlDataReader myReader = cmd.ExecuteReader();




                cmd.Dispose();
                myReader.Close();
                sqlc.Close();


            }
        }
    }
}